Model Table SALARY REVIEW INFO

Attributes

Attribute Description (where applicable)
BENCHMARK_MAX_SALARY
BENCHMARK_MID_SALARY
BENCHMARK_MIN_SALARY
CURRENT_BASE_SALARY
CURRENT_COMPA_RATIO
CURRENT_RANGE_PENETRATION
CURRENT_VARIABLE_PAY
CalculatedNewCompaRatio
CompaRatioColumnOrder
CompaRatioGroups
DIM_EMP_NO_RLS
NEW_BASE_SALARY
NEW_COMPA_RATIO
NEW_RANGE_PENETRATION
NEW_SALARY
NEW_VARIABLE_PAY
SALARY_PLAN_PERIOD

USED BY MODEL(S)

Model Name
Salary Review Analysis

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SALARY REVIEW INFOFACT_SALARY_REVIEW_INFO_TMFACT_SALARY_REVIEW_INFO_BIFACT_SALARY_REVIEW_INFOData Mart